How to: Find a value in a worksheet.
Solution:
Select 'Find...' from the 'Edit' menu, type the value to be found in the 'Find What' box, and select 'Values' from the 'Look in' drop-down list box.
1) Select the 'Edit' menu and select 'Find...'. (The Find dialog box appears.)
2) Type the value to be found in 'Find What' box.
NOTE: If the exact value is unknown, use question marks (?) or asterisks (*). Question marks and asterisks are wildcard characters. A question mark is used to represent any single character while an asterisk is used to represent any number of characters. If searching for a question mark or asterisk, precede these characters with a tilde (~).
EXAMPLE: To search for a value starting with '50', type the following: 50*
3) Select 'By Rows' or 'By Columns' from the 'Search' drop-down list.
4) Select 'Values' from the 'Look in' drop-down list.
Finding a value
5) (Optional) Select the 'Find Entire Cells Only' check box to find exact and complete matches only.
6) Click 'Find Next'.
7) Click 'Close' when the value is found.
